/* Create App Pool User on Server */

CREATE LOGIN [IIS APPPOOL\QAA] 
  FROM WINDOWS WITH DEFAULT_DATABASE=[master], 
  DEFAULT_LANGUAGE=[us_english]
GO


/* Create App Pool User on Database
This user may already be created */

USE [CTLocalDB]
GO

CREATE USER [CrystalTestIISUser] 
  FOR LOGIN [IIS APPPOOL\QAA]
GO

EXEC sp_addrolemember 'db_owner', 'CrystalTestIISUser'
GO